xp-dev.com Git - namibia/blob - data/old_b4c stuff/templates_sale_seller.sql

   1 UPDATE `mig_db`.`lib_template` SET `tags` = 'first_name,family_name,vehicle,price,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email,seller,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email,stock_number', `email_template` = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   4  <head>
   5         <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
   6         <title></title>
   7  </head>
   8  <body style="padding:0;margin:0;">
   9         <!-- Begin 100% Wrapping Table -->
  10         <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
  11                 <tr>
  12                         <td style="padding:20px 0;">
  13                                 <!-- Begin Main Template Table -->
  14                                 <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">
  15                                         <tr>
  16                                                 <td>
  17                                                 <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
  18                                                 </td>
  19                                         </tr>
  20                                         <tr>
  21                                                 <td style="background:#f6f6f6;padding:20px 0">
  22                                                         <!-- Main Content table -->
  23                                                         <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
  24                                                                 <tr>
  25                                                                         <!-- Spacing Column -->
  26                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
  27                                                                         <!-- Main Column -->
  28                                                                         <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
  29                                                                                 <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>
  30                                                                                 <p style="margin:0 0 1em;padding:0;">
  31                                                                                         &nbsp;
  32                                                                                 </p>
  33                                                                                 <p style="margin:0 0 1em;padding:0;">
  34                                                                                         Hello [first_name] [family_name],
  35                                                                                 </p>
  36                      <p style="margin:0 0 1em;padding:0;">
  37                        Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].
  38                      </p>
  39                      <p style="margin:0 0 1em;padding:0;">
  40                        <b>Your responsibilities:</b>
  41                        <ul>
  42                          <li>Invoice vehicle.</li>
  43                          <li>Send Natis, invoice and bank details.</li>
  44                          <li>Have vehicle ready for collection.</li>
  45                          <li>Print attachments.</li>
  46                        </ul>
  47                      </p>
  48                      <p style="margin:0 0 1em;padding:0;">
  49                        <b>Buyer:</b>
  50                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
  51                          <tr>
  52                            <td width="80px"><b>Trading Name:</b></td>
  53                            <td><b>[buyer]</b></td>
  54                          </tr>
  55                          <tr>
  56                            <td width="80px"><b>Full Name:</b></td>
  57                            <td><b>[buyer_name]</b></td>
  58                          </tr>
  59                          <tr>
  60                            <td width="80px"><b>Physical Address:</b></td>
  61                            <td><b>[buyer_address]</b></td>
  62                          </tr>
  63                          <tr>
  64                            <td width="80px"><b>VAT Number:</b></td>
  65                            <td><b>[buyer_vat_number]</b></td>
  66                          </tr>
  67                          <tr>
  68                            <td width="80px"><b>Cellphone:</b></td>
  69                            <td><b>[buyer_mobile]</b></td>
  70                          </tr>
  71                          <tr>
  72                            <td width="80px"><b>E-mail:</b></td>
  73                            <td><b>[buyer_email]</b></td>
  74                          </tr>
  75                        </table>
  76
  77
  78                      </p>
  79
  80                                          <br><br>
  81                                          <p style="margin:0 0 1em;padding:0;">
  82                        <b>Seller:</b>
  83                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
  84                          <tr>
  85                            <td width="80px"><b>Trading Name:</b></td>
  86                            <td><b>[seller]</b></td>
  87                          </tr>
  88                          <tr>
  89                            <td width="80px"><b>Full Name:</b></td>
  90                            <td><b>[seller_name]</b></td>
  91                          </tr>
  92                          <tr>
  93                            <td width="80px"><b>Auction Address:</b></td>
  94                            <td><b>[vehicle_address]</b></td>
  95                          </tr>
  96                          <tr>
  97                            <td width="80px"><b>Billing Address:</b></td>
  98                            <td><b>[seller_billing_address]</b></td>
  99                          </tr>
 100                          <tr>
 101                            <td width="80px"><b>VAT Number:</b></td>
 102                            <td><b>[seller_vat_number]</b></td>
 103                          </tr>
 104                          <tr>
 105                            <td width="80px"><b>E-mail:</b></td>
 106                            <td><b>[seller_email]</b></td>
 107                          </tr>
 108                                                   <tr>
 109                            <td width="80px"><b>Stock Number:</b></td>
 110                            <td><b>[stock_number]</b></td>
 111                          </tr>
 112                        </table>
 113                      </p>
 114                      <p style="margin:0 0 1em;padding:0;"><br/>
 115                        Regards,<br/>
 116                        The Bid4Cars Team
 117                      </p>
 118                                                                         </td>
 119                                                                         <!-- Spacing Column -->
 120                                                                         <td width="40" valign="top" style="width:40px;">&nbsp;</td>
 121                                                                         <!-- Side Column -->
 122                                                                         <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
 123                                                                                 <img src="{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />
 124                                                                                 <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>
 125                                                                                 <p style="margin:0 0 1em;padding:5px;">
 126                                                                                         Online technology bringing buyers and sellers
 127                                                                                         together through the Dealer Network.
 128                                                                                 </p>
 129                                                                         </td>
 130                                                                         <!-- Spacing Column -->
 131                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
 132                                                                 </tr>
 133                                                         </table>
 134                                                         <!-- /Main Content Table -->
 135                                                 </td>
 136                                         </tr>
 137                                         <tr>
 138                                                 <td style="background:#ececec;padding:10px 0 0;">
 139                                                         <!-- Begin Footer table -->
 140                                                         <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">
 141                                                                 <tr>
 142                                                                         <!-- Spacing Column -->
 143                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
 144                                                                         <!-- Main Column -->
 145                                                                         <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">
 146                                                                                 <p style="margin:0 0 1em;padding:0;"><b>demo.bid4cars.com.na</b></p>
 147                                                                         </td>
 148                                                                         <!-- Spacing Column -->
 149                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>
 150                                                                 </tr>
 151                                                         </table>
 152                                                         <!-- /End Footer Table -->
 153                                                 </td>
 154                                         </tr>
 155                                 </table>
 156                                 <!-- /End Main Template Table -->
 157                         </td>
 158                 </tr>
 159         </table>
 160  <!-- /End 100% Wrapping Table  -->
 161  </body>
 162  </html>
 163  ' WHERE `lib_template`.`id` = 6;